﻿

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;


public class BLL_tbl_qcsicomill_xrf
{
    public BLL_tbl_qcsicomill_xrf()
    {

    }

    public List<tbl_qcsicomill_xrf> select(int QC_XRF_ID)
    {
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        return dal.select(QC_XRF_ID);
    }

    public List<tbl_qcsicomill_xrf> selectAll()
    {
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        return dal.selectAll();
    }
    public DataTable selectAllForGrid()
    {
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        return dal.selectAllForGrid();
    }
    public bool insert(List<tbl_qcsicomill_xrf> list)
    {
        bool ret = false;
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        ret = dal.insert(list);
        return ret;
    }
    public bool insert(tbl_qcsicomill_xrf tbl)
    {
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        int i = 0;
        i = dal.insert(
            tbl.Work_Order_Number
, tbl.DRUM_Number
,tbl.Budgeted_Qty
,tbl.Actual_Qty
, tbl.Fe
, tbl.Al
, tbl.Ca
, tbl.Remark
, tbl.IS_ACTIVE
, tbl.CREATED_BY
, tbl.CREATED_DATE
        );

        return Convert.ToBoolean(i);
    }

    public bool update(List<tbl_qcsicomill_xrf> list)
    {
        bool ret = false;
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        ret = dal.update(list);
        return ret;
    }

    public bool update(tbl_qcsicomill_xrf tbl)
    {
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        int i = 0;
        i = dal.update(
            tbl.QC_XRF_ID
, tbl.Work_Order_Number
, tbl.DRUM_Number
,tbl.Budgeted_Qty
,tbl.Actual_Qty
, tbl.Fe
, tbl.Al
, tbl.Ca
, tbl.Remark
, tbl.IS_ACTIVE
, tbl.UPDATED_BY
, tbl.UPDATED_DATE
            );

        return Convert.ToBoolean(i);
    }


    public bool delete(tbl_qcsicomill_xrf tbl)
    {
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        int i = 0;
        i = dal.delete(
                tbl.QC_XRF_ID
        );

        return Convert.ToBoolean(i);
    }

    public List<tbl_qcsicomill_xrf> ddlWorkOrderForLeco_carbon()
    {
        DAL_tbl_qcsicomill_xrf dal = new DAL_tbl_qcsicomill_xrf();
        return dal.ddlWorkOrderForLeco_carbon();
    }
}

